<html>
<body>


Contact database administrator to restore data
<BR>
Process to restore:
1. drop table
- Drop all the tables listed in the file 'data_tables.txt'
2. create table (apply any documented alter commands)
- For each table listed in the 'data_tables.txt' file find the create and alter commands to rebuild them in the file 'table_definitions.txt'.
3. load data
- Use data load file sytax to put the table data back in the system. (http://dev.mysql.com/doc/refman/5.0/en/load-data.html)
- Example: LOAD DATA INFILE 'H:\\211\\Follow-up Access Data\\211QA_Backup\\Data\\##########_Caller.dat' INTO TABLE QA.Caller;
4. Verify
- Check with select statements to verify the expected ammount of data is there and that the process didn't leave the old data set or failed to load the restored data.
- Try creating a new user record with test data, verify it gets entered, then use the purge last call feature to cleanup the test entry.

DONE!

</body>
</html>